This dialog box appears when you choose the Report Options command from the File menu.
Note: These options also appear in the Options dialog box. Use the Options dialog box to change the default values for the program, use the Report Options dialog box to change the options for the current report.
Using this list, specify if you want Date/Time string fields from Microsoft Access automatically converted to:
This list enables you to select the default level of magnification for displaying reports on the Preview tab.
By default, the selector is set to Full Size.
Note: All of the functions available in the Preview tab are available at every magnification.
Selecting this check box forces the program to convert any null values to the database field default. Some databases treat a null as zero, some as a blank, and some as a special null value.
This option is like the Translate DOS Memos option. The only difference is that it is active for string fields instead of memo fields.
Note: If this check box is not selected and you have used upper ASCII characters in your dBASE string fields, the special characters will not be the same in your report as they are in the dBASE string field.
By default, the Translate DOS Strings check box is selected.
When you insert special characters in dBASE memo fields, you use the upper ASCII character set (those characters with decimal values between 128 and 255). When you insert special characters into Windows programs, you use ANSI codes to do so. If you include upper ASCII characters in dBASE memo fields and then use those fields to create a reports, the program would read the codes and assume they were ANSI codes were it not for the Translate DOS Memos option.
Note: If this check box is not selected and you have used upper ASCII characters in your dBASE memo fields, the special characters will not be the same in your report as they are in the dBASE memo field.
By default, the Translate DOS Memos check box is selected.
Select this check box to save the current data with the report.
Select this check box to save summary information with your report.
Use this check box to produce all possible combinations of the original data. This option is not selected by default.
Note: The Cartesian Product option applies to OLAP data sources and does not apply specifically to other direct access data sources. The option ensures a report shows all values of all dimensions (as opposed to all values of the first dimension by one value of the second dimension, which would be the result if the option was not selected).
Select this option to suppress the printing of a report if that report does not contain any records.
Use this check box if you would like report drill
Select this check box to ensure your records are sorted locally even if they were pre
When you select this check box, the program uses available indexes/servers to speed the record selection process.
When you clear this check box, the program selects records without the use of indexes/specified servers (a much slower process).
Note: If an index has a different name than the database it indexes, you need to identify the index for the program. You do this using the Link Options dialog box, which is accessed from the Visual Linking Expert.
This check box is only available if the Use Indexes or Server For Speed check box is selected.
Select this check box to have the program perform grouping on the server (server
Server
This option is not selected by default.
Using this check box tells the program to use more verbose error messages when a Report Engine error occurs.
This check box specifies whether or not the SQL data you use in the report becomes case sensitive. If the data you are using contains fields where the data is in both upper case and lower case, and you do not wish to categorize the data by this aspect, select this check box.
Note: Case Sensitive SQL data is not supported in the 32
Use this option to select only unique records from SQL tables in your database. By selecting this option in the Report Options dialog box, you set the option for the current report. Alternatively, you can set the option for all reports by switching on the Select Distinct Records command on the Database menu.
When you browse a field, by default you see the first 500 unique values of the field. You can change this for the current report by clearing this option. If Select Distinct Data for Browsing is not selected, browsing returns the unique values in the first 500 records.
Note: Note that since most SQL servers do not support selecting distinct records for long data types such as memo and blob fields, selecting and browsing distinct records are not supported for such fields.
When this check box is selected, the program uses asynchronous queries. The program normally sends an entire query to the database server. Selecting this option, however, allows the program and the ODBC database server (if it supports asynchronous queries) to transfer data back and forth. An advantage of using this option is you can cancel queries during processing more easily. This option is not selected by default.
Select this check box to create a Group Tree for use in the Preview tab. Using the Group Tree view, you can drill
Select this check box if you want to see relevant Report Alerts when you refresh your report. This option is selected by default.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |